package mest.dao.cxj;

import mest.Dto.cxj.WorkRouteDto;
import mest.entity.work_file;
import mest.entity.work_route;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface WorkRouteDao {


    /**
     * 新增工艺档案
     *
     * @param workRoute
     * @return
     */
    int insertWorkRoute(@Param("workRoute") work_route workRoute, @Param("theirDb") String theirDb);

    /**
     * 查询所有工艺及存货
     *
     * @param page
     * @param limit
     * @param routeName
     * @return
     */
    List<WorkRouteDto> selectAllWorkRouteAndSave(@Param("page") Integer page, @Param("limit") Integer limit,
                                                 @Param("routeName") String routeName, @Param("theirDb") String theirDb);


    /**
     * 查询工艺档案数量
     *
     * @param routeName
     * @return
     */
    Integer selectCountWorkRoute(@Param("routeName") String routeName, @Param("theirDb") String theirDb);


    /**
     * 假删数据
     */
    int deleteWorkRoute(@Param("id") Integer id, @Param("theirDb") String theirDb);


}